package com.southwind.springboottest.entity.repository;

import com.southwind.springboottest.entity.School;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.JpaRepository;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;

public interface SchoolRepository extends JpaRepository<School,String> {
    Page<School> findByNameLike(Pageable var1, String name);
    List<School> findByProvince(String province);
    List<School> findByTypeLike(String type);

//    @Select("select * from school")
//    List<School> SelectAll();
//
//    @Select("select * from school where schoolname LIKE #{str};")
//    List<School> SelectName(String str);
//
//    @Select("select * from school where province = #{str};")
//    List<School> SelectPro(String str);
//
//    @Select("select * from school where type LIKE #{str};")
//    List<School> SelectType(String str);
}
